Backup duration by type, number of threads, and disk type, faceted by –parallel threads. The horizontal line on each graph shows the duration for the baseline (non compressed, non encrypted) backup.
The following graphs show tps for sysbench oltp (16 threads, 10M rows per table, 16 tables) while xtrabackup runs. Duration is not the same for all graphs as backups don't all last the same, which is why the faceting by –parallel threads produces graphs with varying width.
In all cases, the experiment was run as follows :
The following graph shows disk busy percentage (as reported by pt-diskstats) per parallel threads, by backup type and threads. In all cases, ssd is the drive hosting MySQL's datadir, and hdd is the backup destination drive.